Reporte de Calidad - station

Dataset statistics

Number of variables	16
Number of observations	2589083
Missing cells	11664492
Missing cells (%)	28.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	740.7 MiB
Average record size in memory	300.0 B

Variable types

Text	1
DateTime	1
Numeric	13
Categorical	1

Alerts

`AQI` is highly overall correlated with `PM10` and 1 other fields	High correlation
`Benzene` is highly overall correlated with `Toluene` and 1 other fields	High correlation
`NO` is highly overall correlated with `NOx`	High correlation
`NO2` is highly overall correlated with `NOx`	High correlation
`NOx` is highly overall correlated with `NO` and 1 other fields	High correlation
`PM10` is highly overall correlated with `AQI` and 1 other fields	High correlation
`PM2.5` is highly overall correlated with `AQI` and 1 other fields	High correlation
`Toluene` is highly overall correlated with `Benzene` and 1 other fields	High correlation
`Xylene` is highly overall correlated with `Benzene` and 1 other fields	High correlation
`PM2.5` has 647689 (25.0%) missing values	Missing
`PM10` has 1119252 (43.2%) missing values	Missing
`NO` has 553711 (21.4%) missing values	Missing
`NO2` has 528973 (20.4%) missing values	Missing
`NOx` has 490808 (19.0%) missing values	Missing
`NH3` has 1236618 (47.8%) missing values	Missing
`CO` has 499302 (19.3%) missing values	Missing
`SO2` has 742737 (28.7%) missing values	Missing
`O3` has 725973 (28.0%) missing values	Missing
`Benzene` has 861579 (33.3%) missing values	Missing
`Toluene` has 1042366 (40.3%) missing values	Missing
`Xylene` has 2075104 (80.1%) missing values	Missing
`AQI` has 570190 (22.0%) missing values	Missing
`AQI_Bucket` has 570190 (22.0%) missing values	Missing
`CO` is highly skewed (γ1 = 33.50808698)	Skewed
`Benzene` is highly skewed (γ1 = 21.34590047)	Skewed
`NOx` has 117924 (4.6%) zeros	Zeros
`CO` has 181502 (7.0%) zeros	Zeros
`Benzene` has 392342 (15.2%) zeros	Zeros
`Toluene` has 312987 (12.1%) zeros	Zeros
`Xylene` has 208359 (8.0%) zeros	Zeros

Reproduction

Analysis started	2025-01-05 00:40:35.434698
Analysis finished	2025-01-05 00:41:32.057904
Duration	56.62 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

StationId
Text

Distinct	110
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	153.1 MiB

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	12945415
Distinct characters	29
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AP001
2nd row	AP001
3rd row	AP001
4th row	AP001
5th row	AP001

Value	Count	Frequency (%)
ka003	48192	1.9%
dl013	48192	1.9%
tn004	48192	1.9%
tn003	48192	1.9%
tn001	48192	1.9%
up012	48192	1.9%
up014	48192	1.9%
dl007	48192	1.9%
dl008	48192	1.9%
gj001	48192	1.9%
Other values (100)	2107163	81.4%

Most occurring characters

Value	Count	Frequency (%)
0	4104970	31.7%
1	1161659	9.0%
L	1132467	8.7%
D	1132017	8.7%
3	556792	4.3%
2	524441	4.1%
T	372708	2.9%
A	357403	2.8%
4	350757	2.7%
K	325241	2.5%
Other values (19)	2926960	22.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12945415	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4104970	31.7%
1	1161659	9.0%
L	1132467	8.7%
D	1132017	8.7%
3	556792	4.3%
2	524441	4.1%
T	372708	2.9%
A	357403	2.8%
4	350757	2.7%
K	325241	2.5%
Other values (19)	2926960	22.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12945415	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4104970	31.7%
1	1161659	9.0%
L	1132467	8.7%
D	1132017	8.7%
3	556792	4.3%
2	524441	4.1%
T	372708	2.9%
A	357403	2.8%
4	350757	2.7%
K	325241	2.5%
Other values (19)	2926960	22.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12945415	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4104970	31.7%
1	1161659	9.0%
L	1132467	8.7%
D	1132017	8.7%
3	556792	4.3%
2	524441	4.1%
T	372708	2.9%
A	357403	2.8%
4	350757	2.7%
K	325241	2.5%
Other values (19)	2926960	22.6%

Datetime
Date

Distinct	48192
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	19.8 MiB

Minimum	2015-01-01 01:00:00
Maximum	2020-07-01 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

PM2.5
Real number (ℝ)

High correlation Missing

Distinct	45086
Distinct (%)	2.3%
Missing	647689
Missing (%)	25.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.864814

Minimum	0.01
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0.01
5-th percentile	10
Q1	28.16
median	52.59
Q3	97.74
95-th percentile	251.29
Maximum	1000
Range	999.99
Interquartile range (IQR)	69.58

Descriptive statistics

Standard deviation	89.476181
Coefficient of variation (CV)	1.1064909
Kurtosis	18.305458
Mean	80.864814
Median Absolute Deviation (MAD)	29.59
Skewness	3.3444117
Sum	1.5699046 × 10⁸
Variance	8005.987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	4989	0.2%
27	4970	0.2%
33	4793	0.2%
56	4782	0.2%
28	4717	0.2%
39	4697	0.2%
29	4684	0.2%
40	4649	0.2%
38	4629	0.2%
25	4537	0.2%
Other values (45076)	1893947	73.2%
(Missing)	647689	25.0%

Value	Count	Frequency (%)
0.01	39	< 0.1%
0.02	55	< 0.1%
0.03	68	< 0.1%
0.04	56	< 0.1%
0.05	56	< 0.1%
0.06	39	< 0.1%
0.07	45	< 0.1%
0.08	44	< 0.1%
0.09	40	< 0.1%
0.1	63	< 0.1%

Value	Count	Frequency (%)
1000	182	< 0.1%
999.99	478	< 0.1%
999.83	1	< 0.1%
999.75	2	< 0.1%
999.5	2	< 0.1%
999.25	1	< 0.1%
998.75	1	< 0.1%
998.09	1	< 0.1%
998	1	< 0.1%
997.93	1	< 0.1%

PM10
Real number (ℝ)

High correlation Missing

Distinct	56960
Distinct (%)	3.9%
Missing	1119252
Missing (%)	43.2%
Infinite	0
Infinite (%)	0.0%
Mean	158.48391

Minimum	0.01
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0.01
5-th percentile	25
Q1	64
median	116.25
Q3	204
95-th percentile	440.75
Maximum	1000
Range	999.99
Interquartile range (IQR)	140

Descriptive statistics

Standard deviation	139.78826
Coefficient of variation (CV)	0.8820344
Kurtosis	5.5620304
Mean	158.48391
Median Absolute Deviation (MAD)	62.25
Skewness	2.0478487
Sum	2.3294456 × 10⁸
Variance	19540.757
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
94	4818	0.2%
56	1880	0.1%
69	1827	0.1%
59	1821	0.1%
53	1816	0.1%
80	1804	0.1%
64	1779	0.1%
50	1774	0.1%
86	1770	0.1%
72	1758	0.1%
Other values (56950)	1448784	56.0%
(Missing)	1119252	43.2%

Value	Count	Frequency (%)
0.01	25	< 0.1%
0.02	30	< 0.1%
0.03	45	< 0.1%
0.04	35	< 0.1%
0.05	36	< 0.1%
0.06	49	< 0.1%
0.07	32	< 0.1%
0.08	44	< 0.1%
0.09	37	< 0.1%
0.1	47	< 0.1%

Value	Count	Frequency (%)
1000	189	< 0.1%
999.99	236	< 0.1%
999.96	1	< 0.1%
999.83	1	< 0.1%
999.75	3	< 0.1%
999.33	1	< 0.1%
999.16	1	< 0.1%
999	2	< 0.1%
998.9	1	< 0.1%
998.58	1	< 0.1%

NO
Real number (ℝ)

High correlation Missing

Distinct	36985
Distinct (%)	1.8%
Missing	553711
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	22.788253

Minimum	0.01
Maximum	500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0.01
5-th percentile	0.88
Q1	3.05
median	7.15
Q3	18.58
95-th percentile	103.04
Maximum	500
Range	499.99
Interquartile range (IQR)	15.53

Descriptive statistics

Standard deviation	48.461463
Coefficient of variation (CV)	2.1265984
Kurtosis	28.356179
Mean	22.788253
Median Absolute Deviation (MAD)	5.04
Skewness	4.7654233
Sum	46382573
Variance	2348.5134
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	4452	0.2%
3	4151	0.2%
1.5	4072	0.2%
0.8	3966	0.2%
2.1	3930	0.2%
2	3922	0.2%
2.5	3839	0.1%
1.1	3825	0.1%
1.4	3813	0.1%
0.9	3805	0.1%
Other values (36975)	1995597	77.1%
(Missing)	553711	21.4%

Value	Count	Frequency (%)
0.01	189	< 0.1%
0.02	249	< 0.1%
0.03	268	< 0.1%
0.04	222	< 0.1%
0.05	230	< 0.1%
0.06	203	< 0.1%
0.07	253	< 0.1%
0.08	277	< 0.1%
0.09	191	< 0.1%
0.1	1447	0.1%

Value	Count	Frequency (%)
500	1	< 0.1%
499.99	2	< 0.1%
499.9	1	< 0.1%
499.8	3	< 0.1%
499.76	2	< 0.1%
499.74	1	< 0.1%
499.7	3	< 0.1%
499.67	1	< 0.1%
499.65	1	< 0.1%
499.63	1	< 0.1%

NO2
Real number (ℝ)

High correlation Missing

Distinct	26703
Distinct (%)	1.3%
Missing	528973
Missing (%)	20.4%
Infinite	0
Infinite (%)	0.0%
Mean	35.236891

Minimum	0.01
Maximum	499.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0.01
5-th percentile	4.33
Q1	13.1
median	24.79
Q3	45.48
95-th percentile	100.3
Maximum	499.99
Range	499.98
Interquartile range (IQR)	32.38

Descriptive statistics

Standard deviation	34.975083
Coefficient of variation (CV)	0.99257004
Kurtosis	17.480945
Mean	35.236891
Median Absolute Deviation (MAD)	14.01
Skewness	3.0633094
Sum	72591872
Variance	1223.2564
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	1210	< 0.1%
7	1171	< 0.1%
0.2	1147	< 0.1%
8	1119	< 0.1%
15	1109	< 0.1%
10	1030	< 0.1%
14	1021	< 0.1%
12	991	< 0.1%
14.5	988	< 0.1%
11	981	< 0.1%
Other values (26693)	2049343	79.2%
(Missing)	528973	20.4%

Value	Count	Frequency (%)
0.01	180	< 0.1%
0.02	313	< 0.1%
0.03	358	< 0.1%
0.04	310	< 0.1%
0.05	258	< 0.1%
0.06	265	< 0.1%
0.07	281	< 0.1%
0.08	246	< 0.1%
0.09	199	< 0.1%
0.1	678	< 0.1%

Value	Count	Frequency (%)
499.99	2	< 0.1%
499.97	1	< 0.1%
499.9	1	< 0.1%
499.8	1	< 0.1%
499.51	1	< 0.1%
499.28	1	< 0.1%
498.96	1	< 0.1%
498.4	1	< 0.1%
498.3	1	< 0.1%
498.15	1	< 0.1%

NOx
Real number (ℝ)

High correlation Missing Zeros

Distinct	40690
Distinct (%)	1.9%
Missing	490808
Missing (%)	19.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.551148

Minimum	0
Maximum	500
Zeros	117924
Zeros (%)	4.6%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	11.35
median	22.86
Q3	45.7
95-th percentile	143.35
Maximum	500
Range	500
Interquartile range (IQR)	34.35

Descriptive statistics

Standard deviation	55.908938
Coefficient of variation (CV)	1.3787264
Kurtosis	17.000603
Mean	40.551148
Median Absolute Deviation (MAD)	14.23
Skewness	3.6031296
Sum	85087461
Variance	3125.8094
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	117924	4.6%
6.24	13528	0.5%
2.21	11571	0.4%
5	1349	0.1%
4.9	1216	< 0.1%
7	1172	< 0.1%
10	1161	< 0.1%
9	1155	< 0.1%
11	1105	< 0.1%
11.5	1065	< 0.1%
Other values (40680)	1947029	75.2%
(Missing)	490808	19.0%

Value	Count	Frequency (%)
0	117924	4.6%
0.01	87	< 0.1%
0.02	82	< 0.1%
0.03	250	< 0.1%
0.04	92	< 0.1%
0.05	194	< 0.1%
0.06	42	< 0.1%
0.07	74	< 0.1%
0.08	124	< 0.1%
0.09	56	< 0.1%

Value	Count	Frequency (%)
500	4	< 0.1%
499.99	2	< 0.1%
499.97	1	< 0.1%
499.95	1	< 0.1%
499.94	1	< 0.1%
499.9	2	< 0.1%
499.87	1	< 0.1%
499.82	1	< 0.1%
499.8	2	< 0.1%
499.73	1	< 0.1%

NH3
Real number (ℝ)

Missing

Distinct	20523
Distinct (%)	1.5%
Missing	1236618
Missing (%)	47.8%
Infinite	0
Infinite (%)	0.0%
Mean	28.708556

Minimum	0.01
Maximum	499.97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0.01
5-th percentile	3.53
Q1	11.23
median	22.35
Q3	37.78
95-th percentile	73.57
Maximum	499.97
Range	499.96
Interquartile range (IQR)	26.55

Descriptive statistics

Standard deviation	27.532443
Coefficient of variation (CV)	0.95903266
Kurtosis	34.330607
Mean	28.708556
Median Absolute Deviation (MAD)	12.38
Skewness	4.0288524
Sum	38827317
Variance	758.03539
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	1494	0.1%
9	1303	0.1%
14.62	988	< 0.1%
7	937	< 0.1%
5	910	< 0.1%
26	869	< 0.1%
10.3	855	< 0.1%
10.5	855	< 0.1%
0.1	854	< 0.1%
12	845	< 0.1%
Other values (20513)	1342555	51.9%
(Missing)	1236618	47.8%

Value	Count	Frequency (%)
0.01	131	< 0.1%
0.02	114	< 0.1%
0.03	149	< 0.1%
0.04	101	< 0.1%
0.05	157	< 0.1%
0.06	67	< 0.1%
0.07	79	< 0.1%
0.08	150	< 0.1%
0.09	49	< 0.1%
0.1	854	< 0.1%

Value	Count	Frequency (%)
499.97	1	< 0.1%
499.56	1	< 0.1%
499.12	1	< 0.1%
498.54	1	< 0.1%
497.99	1	< 0.1%
497.95	1	< 0.1%
497.88	1	< 0.1%
497.38	1	< 0.1%
495.23	1	< 0.1%
494.11	1	< 0.1%

CO
Real number (ℝ)

Missing Skewed Zeros

Distinct	7263
Distinct (%)	0.3%
Missing	499302
Missing (%)	19.3%
Infinite	0
Infinite (%)	0.0%
Mean	1.502366

Minimum	0
Maximum	498.57
Zeros	181502
Zeros (%)	7.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.41
median	0.8
Q3	1.38
95-th percentile	3.62
Maximum	498.57
Range	498.57
Interquartile range (IQR)	0.97

Descriptive statistics

Standard deviation	6.2924451
Coefficient of variation (CV)	4.1883569
Kurtosis	1632.1903
Mean	1.502366
Median Absolute Deviation (MAD)	0.45
Skewness	33.508087
Sum	3139616
Variance	39.594866
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	181502	7.0%
0.7	21885	0.8%
0.6	21096	0.8%
0.8	21087	0.8%
0.4	20810	0.8%
0.5	20721	0.8%
0.3	17503	0.7%
0.55	16393	0.6%
0.72	16217	0.6%
0.65	16175	0.6%
Other values (7253)	1736392	67.1%
(Missing)	499302	19.3%

Value	Count	Frequency (%)
0	181502	7.0%
0.01	4301	0.2%
0.02	3905	0.2%
0.03	2644	0.1%
0.04	2400	0.1%
0.05	2661	0.1%
0.06	2393	0.1%
0.07	2668	0.1%
0.08	3198	0.1%
0.09	2654	0.1%

Value	Count	Frequency (%)
498.57	1	< 0.1%
494.9	1	< 0.1%
490.35	1	< 0.1%
485.73	1	< 0.1%
483.37	1	< 0.1%
476.2	1	< 0.1%
476.02	1	< 0.1%
475.4	1	< 0.1%
473.81	1	< 0.1%
470.72	1	< 0.1%

SO2
Real number (ℝ)

Missing

Distinct	15385
Distinct (%)	0.8%
Missing	742737
Missing (%)	28.7%
Infinite	0
Infinite (%)	0.0%
Mean	12.116025

Minimum	0.01
Maximum	199.96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0.01
5-th percentile	1.38
Q1	4.25
median	8.25
Q3	14.53
95-th percentile	34.85
Maximum	199.96
Range	199.95
Interquartile range (IQR)	10.28

Descriptive statistics

Standard deviation	14.673848
Coefficient of variation (CV)	1.2111108
Kurtosis	36.042377
Mean	12.116025
Median Absolute Deviation (MAD)	4.65
Skewness	4.7860374
Sum	22370373
Variance	215.32181
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	3306	0.1%
4	3090	0.1%
2.5	2998	0.1%
2	2920	0.1%
5	2779	0.1%
3.5	2728	0.1%
5.5	2623	0.1%
4.5	2544	0.1%
6	2531	0.1%
7	2522	0.1%
Other values (15375)	1818305	70.2%
(Missing)	742737	28.7%

Value	Count	Frequency (%)
0.01	366	< 0.1%
0.02	464	< 0.1%
0.03	510	< 0.1%
0.04	474	< 0.1%
0.05	388	< 0.1%
0.06	410	< 0.1%
0.07	363	< 0.1%
0.08	395	< 0.1%
0.09	316	< 0.1%
0.1	2303	0.1%

Value	Count	Frequency (%)
199.96	2	< 0.1%
199.95	1	< 0.1%
199.93	1	< 0.1%
199.9	1	< 0.1%
199.85	1	< 0.1%
199.81	1	< 0.1%
199.77	1	< 0.1%
199.75	1	< 0.1%
199.72	1	< 0.1%
199.7	1	< 0.1%

O3
Real number (ℝ)

Missing

Distinct	23226
Distinct (%)	1.2%
Missing	725973
Missing (%)	28.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.064085

Minimum	0.01
Maximum	997
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0.01
5-th percentile	3
Q1	11.02
median	24.75
Q3	49.53
95-th percentile	111.6
Maximum	997
Range	996.99
Interquartile range (IQR)	38.51

Descriptive statistics

Standard deviation	47.106533
Coefficient of variation (CV)	1.2375585
Kurtosis	57.530379
Mean	38.064085
Median Absolute Deviation (MAD)	16.49
Skewness	5.4743607
Sum	70917577
Variance	2219.0254
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	1495	0.1%
3	1364	0.1%
2	1330	0.1%
4	1237	< 0.1%
7	1155	< 0.1%
3.5	1152	< 0.1%
1	1152	< 0.1%
4.5	1122	< 0.1%
5.5	1114	< 0.1%
17	1087	< 0.1%
Other values (23216)	1850902	71.5%
(Missing)	725973	28.0%

Value	Count	Frequency (%)
0.01	195	< 0.1%
0.02	213	< 0.1%
0.03	184	< 0.1%
0.04	136	< 0.1%
0.05	119	< 0.1%
0.06	127	< 0.1%
0.07	145	< 0.1%
0.08	124	< 0.1%
0.09	105	< 0.1%
0.1	636	< 0.1%

Value	Count	Frequency (%)
997	1	< 0.1%
996	2	< 0.1%
992	1	< 0.1%
989	1	< 0.1%
988.17	1	< 0.1%
984.33	1	< 0.1%
982	2	< 0.1%
980	1	< 0.1%
977	1	< 0.1%
975	1	< 0.1%

Benzene
Real number (ℝ)

High correlation Missing Skewed Zeros

Distinct	11356
Distinct (%)	0.7%
Missing	861579
Missing (%)	33.3%
Infinite	0
Infinite (%)	0.0%
Mean	3.3054932

Minimum	0
Maximum	498.07
Zeros	392342
Zeros (%)	15.2%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.08
median	0.96
Q3	3.23
95-th percentile	11.8
Maximum	498.07
Range	498.07
Interquartile range (IQR)	3.15

Descriptive statistics

Standard deviation	12.140528
Coefficient of variation (CV)	3.6728341
Kurtosis	662.1786
Mean	3.3054932
Median Absolute Deviation (MAD)	0.96
Skewness	21.3459
Sum	5710252.7
Variance	147.39242
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	392342	15.2%
0.1	44769	1.7%
0.2	23687	0.9%
0.3	16939	0.7%
0.4	14282	0.6%
0.35	9732	0.4%
0.23	9314	0.4%
0.15	8765	0.3%
0.45	8682	0.3%
0.7	8602	0.3%
Other values (11346)	1190390	46.0%
(Missing)	861579	33.3%

Value	Count	Frequency (%)
0	392342	15.2%
0.01	6150	0.2%
0.02	4273	0.2%
0.03	7334	0.3%
0.04	4581	0.2%
0.05	6631	0.3%
0.06	3142	0.1%
0.07	3564	0.1%
0.08	6076	0.2%
0.09	3149	0.1%

Value	Count	Frequency (%)
498.07	4	< 0.1%
491.51	8	< 0.1%
490	1	< 0.1%
488.48	1	< 0.1%
487.79	1	< 0.1%
487.6	1	< 0.1%
487.21	1	< 0.1%
487.2	1	< 0.1%
486.58	1	< 0.1%
485.69	1	< 0.1%

Toluene
Real number (ℝ)

High correlation Missing Zeros

Distinct	24266
Distinct (%)	1.6%
Missing	1042366
Missing (%)	40.3%
Infinite	0
Infinite (%)	0.0%
Mean	14.902663

Minimum	0
Maximum	499.99
Zeros	312987
Zeros (%)	12.1%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.34
median	3.4
Q3	15.1
95-th percentile	64.35
Maximum	499.99
Range	499.99
Interquartile range (IQR)	14.76

Descriptive statistics

Standard deviation	33.297295
Coefficient of variation (CV)	2.2343184
Kurtosis	49.998524
Mean	14.902663
Median Absolute Deviation (MAD)	3.4
Skewness	5.8398176
Sum	23050203
Variance	1108.7098
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	312987	12.1%
0.1	7138	0.3%
0.2	6966	0.3%
0.3	5665	0.2%
1.1	5423	0.2%
0.5	5136	0.2%
0.6	4530	0.2%
0.8	4172	0.2%
0.9	4073	0.2%
0.4	3690	0.1%
Other values (24256)	1186937	45.8%
(Missing)	1042366	40.3%

Value	Count	Frequency (%)
0	312987	12.1%
0.01	1297	0.1%
0.02	1735	0.1%
0.03	2474	0.1%
0.04	1682	0.1%
0.05	2305	0.1%
0.06	2359	0.1%
0.07	2030	0.1%
0.08	2292	0.1%
0.09	1353	0.1%

Value	Count	Frequency (%)
499.99	1	< 0.1%
499.8	1	< 0.1%
499.5	2	< 0.1%
499.4	1	< 0.1%
499.2	1	< 0.1%
499.08	1	< 0.1%
499.05	1	< 0.1%
498.9	1	< 0.1%
498.8	1	< 0.1%
498.6	1	< 0.1%

Xylene
Real number (ℝ)

High correlation Missing Zeros

Distinct	5829
Distinct (%)	1.1%
Missing	2075104
Missing (%)	80.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.4488809

Minimum	0
Maximum	499.99
Zeros	208359
Zeros (%)	8.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.2
Q3	1.83
95-th percentile	10.82
Maximum	499.99
Range	499.99
Interquartile range (IQR)	1.83

Descriptive statistics

Standard deviation	8.9734698
Coefficient of variation (CV)	3.6643145
Kurtosis	444.26888
Mean	2.4488809
Median Absolute Deviation (MAD)	0.2
Skewness	16.347887
Sum	1258673.4
Variance	80.523161
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	208359	8.0%
0.1	11522	0.4%
2	6184	0.2%
0.65	5635	0.2%
0.2	4107	0.2%
0.3	3815	0.1%
0.03	3739	0.1%
0.05	3618	0.1%
0.4	3460	0.1%
0.15	3030	0.1%
Other values (5819)	260510	10.1%
(Missing)	2075104	80.1%

Value	Count	Frequency (%)
0	208359	8.0%
0.01	1971	0.1%
0.02	1546	0.1%
0.03	3739	0.1%
0.04	1815	0.1%
0.05	3618	0.1%
0.06	1202	< 0.1%
0.07	1559	0.1%
0.08	3010	0.1%
0.09	1067	< 0.1%

Value	Count	Frequency (%)
499.99	1	< 0.1%
476.31	1	< 0.1%
461.39	1	< 0.1%
433.94	1	< 0.1%
423.48	1	< 0.1%
422.86	1	< 0.1%
419.88	1	< 0.1%
406.29	1	< 0.1%
402.64	1	< 0.1%
398.9	1	< 0.1%

AQI
Real number (ℝ)

High correlation Missing

Distinct	1601
Distinct (%)	0.1%
Missing	570190
Missing (%)	22.0%
Infinite	0
Infinite (%)	0.0%
Mean	180.17303

Minimum	5
Maximum	3133
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.8 MiB

Quantile statistics

Minimum	5
5-th percentile	44
Q1	84
median	131
Q3	259
95-th percentile	416
Maximum	3133
Range	3128
Interquartile range (IQR)	175

Descriptive statistics

Standard deviation	140.40953
Coefficient of variation (CV)	0.77930384
Kurtosis	38.303665
Mean	180.17303
Median Absolute Deviation (MAD)	63
Skewness	3.4454512
Sum	3.6375006 × 10⁸
Variance	19714.837
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
102	16729	0.6%
104	15664	0.6%
101	15486	0.6%
106	14777	0.6%
100	14516	0.6%
103	14311	0.6%
105	13743	0.5%
108	12742	0.5%
88	12630	0.5%
64	12518	0.5%
Other values (1591)	1875777	72.4%
(Missing)	570190	22.0%

Value	Count	Frequency (%)
5	4	< 0.1%
6	34	< 0.1%
7	64	< 0.1%
8	27	< 0.1%
9	62	< 0.1%
10	112	< 0.1%
11	102	< 0.1%
12	126	< 0.1%
13	128	< 0.1%
14	160	< 0.1%

Value	Count	Frequency (%)
3133	8	< 0.1%
3111	8	< 0.1%
3084	8	< 0.1%
3057	8	< 0.1%
3043	8	< 0.1%
3001	8	< 0.1%
3000	8	< 0.1%
2996	8	< 0.1%
2987	8	< 0.1%
2969	8	< 0.1%

AQI_Bucket
Categorical

Missing

Distinct	6
Distinct (%)	< 0.1%
Missing	570190
Missing (%)	22.0%
Memory size	156.2 MiB

Moderate	675008
Satisfactory	530164
Very Poor	301150
Poor	239990
Good	152113

Length

Max length	12
Median length	9
Mean length	8.3033633
Min length	4

Characters and Unicode

Total characters	16763602
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moderate
2nd row	Moderate
3rd row	Moderate
4th row	Moderate
5th row	Moderate

Common Values

Value	Count	Frequency (%)
Moderate	675008	26.1%
Satisfactory	530164	20.5%
Very Poor	301150	11.6%
Poor	239990	9.3%
Good	152113	5.9%
Severe	120468	4.7%
(Missing)	570190	22.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
moderate	675008	29.1%
poor	541140	23.3%
satisfactory	530164	22.9%
very	301150	13.0%
good	152113	6.6%
severe	120468	5.2%

Most occurring characters

Value	Count	Frequency (%)
o	2591678	15.5%
r	2167930	12.9%
e	2012570	12.0%
a	1735336	10.4%
t	1735336	10.4%
y	831314	5.0%
d	827121	4.9%
M	675008	4.0%
S	650632	3.9%
P	541140	3.2%
Other values (8)	2995537	17.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	16763602	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	2591678	15.5%
r	2167930	12.9%
e	2012570	12.0%
a	1735336	10.4%
t	1735336	10.4%
y	831314	5.0%
d	827121	4.9%
M	675008	4.0%
S	650632	3.9%
P	541140	3.2%
Other values (8)	2995537	17.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	16763602	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	2591678	15.5%
r	2167930	12.9%
e	2012570	12.0%
a	1735336	10.4%
t	1735336	10.4%
y	831314	5.0%
d	827121	4.9%
M	675008	4.0%
S	650632	3.9%
P	541140	3.2%
Other values (8)	2995537	17.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	16763602	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	2591678	15.5%
r	2167930	12.9%
e	2012570	12.0%
a	1735336	10.4%
t	1735336	10.4%
y	831314	5.0%
d	827121	4.9%
M	675008	4.0%
S	650632	3.9%
P	541140	3.2%
Other values (8)	2995537	17.9%

	AQI	AQI_Bucket	Benzene	CO	NH3	NO	NO2	NOx	O3	PM10	PM2.5	SO2	Toluene	Xylene
AQI	1.000	0.412	0.336	0.433	0.487	0.347	0.452	0.424	0.074	0.806	0.777	0.339	0.330	0.131
AQI_Bucket	0.412	1.000	0.025	0.070	0.161	0.141	0.171	0.172	0.125	0.426	0.374	0.116	0.108	0.021
Benzene	0.336	0.025	1.000	0.337	0.283	0.262	0.413	0.376	-0.068	0.362	0.353	0.238	0.819	0.790
CO	0.433	0.070	0.337	1.000	0.354	0.398	0.373	0.445	-0.147	0.454	0.415	0.245	0.380	0.335
NH3	0.487	0.161	0.283	0.354	1.000	0.254	0.422	0.353	0.000	0.475	0.468	0.253	0.352	0.044
NO	0.347	0.141	0.262	0.398	0.254	1.000	0.467	0.737	-0.340	0.389	0.385	0.194	0.229	0.188
NO2	0.452	0.171	0.413	0.373	0.422	0.467	1.000	0.775	-0.079	0.492	0.472	0.265	0.432	0.250
NOx	0.424	0.172	0.376	0.445	0.353	0.737	0.775	1.000	-0.223	0.472	0.437	0.237	0.357	0.277
O3	0.074	0.125	-0.068	-0.147	0.000	-0.340	-0.079	-0.223	1.000	-0.045	-0.038	0.069	-0.080	-0.032
PM10	0.806	0.426	0.362	0.454	0.475	0.389	0.492	0.472	-0.045	1.000	0.874	0.346	0.342	0.072
PM2.5	0.777	0.374	0.353	0.415	0.468	0.385	0.472	0.437	-0.038	0.874	1.000	0.289	0.312	0.155
SO2	0.339	0.116	0.238	0.245	0.253	0.194	0.265	0.237	0.069	0.346	0.289	1.000	0.344	0.235
Toluene	0.330	0.108	0.819	0.380	0.352	0.229	0.432	0.357	-0.080	0.342	0.312	0.344	1.000	0.721
Xylene	0.131	0.021	0.790	0.335	0.044	0.188	0.250	0.277	-0.032	0.072	0.155	0.235	0.721	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	StationId	Datetime	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket
0	AP001	2017-11-24 17:00:00	60.50	98.00	2.35	30.80	18.25	8.50	0.1	11.85	126.40	0.10	6.10	0.10	NaN	NaN
1	AP001	2017-11-24 18:00:00	65.50	111.25	2.70	24.20	15.07	9.77	0.1	13.17	117.12	0.10	6.25	0.15	NaN	NaN
2	AP001	2017-11-24 19:00:00	80.00	132.00	2.10	25.18	15.15	12.02	0.1	12.08	98.98	0.20	5.98	0.18	NaN	NaN
3	AP001	2017-11-24 20:00:00	81.50	133.25	1.95	16.25	10.23	11.58	0.1	10.47	112.20	0.20	6.72	0.10	NaN	NaN
4	AP001	2017-11-24 21:00:00	75.25	116.00	1.43	17.48	10.43	12.03	0.1	9.12	106.35	0.20	5.75	0.08	NaN	NaN
5	AP001	2017-11-24 22:00:00	69.25	108.25	0.70	18.47	10.38	13.80	0.1	9.25	91.10	0.20	5.02	0.00	NaN	NaN
6	AP001	2017-11-24 23:00:00	67.50	111.50	1.05	12.15	7.30	17.65	0.1	9.40	112.70	0.20	5.60	0.10	NaN	NaN
7	AP001	2017-11-25 00:00:00	68.00	111.00	1.25	14.12	8.50	20.28	0.1	8.90	116.12	0.20	5.55	0.05	NaN	NaN
8	AP001	2017-11-25 01:00:00	73.00	102.00	0.30	14.30	7.90	11.50	0.3	11.80	121.50	0.20	6.60	0.00	NaN	NaN
9	AP001	2017-11-25 02:00:00	81.00	123.00	0.80	24.85	13.88	10.28	0.1	11.62	83.80	0.23	6.77	0.10	NaN	NaN

	StationId	Datetime	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket
2589073	WB013	2020-06-30 15:00:00	22.82	36.75	9.85	49.86	59.73	26.28	0.85	3.08	32.38	1.40	6.82	NaN	59.0	Satisfactory
2589074	WB013	2020-06-30 16:00:00	23.00	42.30	6.95	32.79	39.72	23.68	0.70	6.25	57.22	3.18	11.62	NaN	59.0	Satisfactory
2589075	WB013	2020-06-30 17:00:00	17.72	47.25	7.42	26.54	33.95	25.61	0.78	8.81	58.96	1.60	8.50	NaN	59.0	Satisfactory
2589076	WB013	2020-06-30 18:00:00	14.45	42.42	9.32	38.91	48.25	26.21	0.81	34.88	27.57	2.13	9.35	NaN	59.0	Satisfactory
2589077	WB013	2020-06-30 19:00:00	12.35	44.88	8.28	36.44	44.70	32.30	0.78	23.99	16.45	2.13	9.47	NaN	59.0	Satisfactory
2589078	WB013	2020-06-30 20:00:00	15.55	47.80	7.27	35.08	42.38	31.25	0.80	9.40	17.24	2.56	11.57	NaN	59.0	Satisfactory
2589079	WB013	2020-06-30 21:00:00	15.23	42.30	6.10	26.78	32.85	30.66	0.56	4.91	17.46	3.49	12.29	NaN	59.0	Satisfactory
2589080	WB013	2020-06-30 22:00:00	11.40	40.95	6.58	19.53	26.12	30.73	0.61	3.81	17.24	1.83	8.88	NaN	59.0	Satisfactory
2589081	WB013	2020-06-30 23:00:00	9.25	34.33	9.17	21.85	31.00	29.61	0.65	3.44	12.74	1.40	8.43	NaN	59.0	Satisfactory
2589082	WB013	2020-07-01 00:00:00	10.50	36.50	7.78	22.50	30.25	27.23	0.58	2.80	13.10	1.31	7.39	NaN	59.0	Satisfactory

Overview

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample